08. Practice Quiz #1

Let's start with creating a table that provides the following details: actor's first and last name combined as full_name, film title, film description and length of the movie.

How many rows are there in the table?
SOLUTION: 5462 rows

Write a query that creates a list of actors and movies where the movie length was more than 60 minutes. How many rows are there in this query result?
SOLUTION: 4900 rows

Write a query that captures the actor id, full name of the actor, and counts the number of movies each actor has made. * (HINT: Think about whether you should group by actor id or the full name of the actor.*) Identify the actor who has made the maximum number movies.
SOLUTION: Gina Degeneres

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity, so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: sql-evaluator
  • Opened files (when workspace is loaded): n/a

Next Concept